﻿CREATE TABLE [dbo].[Employee_PostMove] (
    [id]                INT              IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL,
    [Eid]               INT              NOT NULL,
    [EName]             NVARCHAR (50)    NOT NULL,
    [BCompanyid]        INT              NOT NULL,
    [BCompanyName]      NVARCHAR (200)   CONSTRAINT [DF_Employee_PostMove_BCompanyName] DEFAULT ('') NULL,
    [BDepartmentid]     NVARCHAR (50)    NULL,
    [BDepartmentName]   NVARCHAR (200)   CONSTRAINT [DF_Employee_PostMove_BDepartmentName] DEFAULT ('') NULL,
    [BPostCategoryId]   INT              CONSTRAINT [DF_Employee_PostMove_BPostCategoryId] DEFAULT ((0)) NULL,
    [BPostId]           INT              NULL,
    [BPostName]         NVARCHAR (50)    CONSTRAINT [DF_Employee_PostMove_BPostName] DEFAULT ('') NULL,
    [BGradeId]          INT              NULL,
    [BGradeName]        NVARCHAR (50)    CONSTRAINT [DF_Employee_PostMove_BGradeName] DEFAULT ('') NULL,
    [BWageNumber]       NVARCHAR (50)    NULL,
    [BZhiWu]            NVARCHAR (50)    NULL,
    [ACompanyid]        INT              NOT NULL,
    [ACompanyName]      NVARCHAR (200)   CONSTRAINT [DF_Employee_PostMove_ACompanyName] DEFAULT ('') NULL,
    [ADepartmentid]     NVARCHAR (50)    NULL,
    [ADepartmentName]   NVARCHAR (200)   CONSTRAINT [DF_Employee_PostMove_ADepartmentName] DEFAULT ('') NULL,
    [APostCategoryId]   INT              CONSTRAINT [DF_Employee_PostMove_APostCategoryId] DEFAULT ((0)) NULL,
    [APostId]           INT              NULL,
    [APostName]         NVARCHAR (50)    CONSTRAINT [DF_Employee_PostMove_APostName] DEFAULT ('') NULL,
    [AGradeId]          INT              NULL,
    [AGradeName]        NVARCHAR (50)    CONSTRAINT [DF_Employee_PostMove_AGradeName] DEFAULT ('') NULL,
    [AWageNumber]       NVARCHAR (50)    CONSTRAINT [DF_Employee_PostMove_AWageNumber] DEFAULT ('') NULL,
    [AState]            INT              NULL,
    [AZhiWu]            NVARCHAR (50)    NULL,
    [Reason]            VARCHAR (MAX)    NULL,
    [Proposer]          NVARCHAR (50)    NULL,
    [ApplionTime]       DATETIME         NULL,
    [FirstAudit]        BIT              CONSTRAINT [DF_Employee_PostMove_FirstAudit] DEFAULT ((0)) NULL,
    [FirstMemo]         VARCHAR (MAX)    NULL,
    [FirstAuditPerson]  NVARCHAR (50)    NULL,
    [FirstAuditTime]    DATETIME         NULL,
    [SecondAudit]       BIT              CONSTRAINT [DF_Employee_PostMove_SecondAudit] DEFAULT ((0)) NULL,
    [SecondMemo]        VARCHAR (MAX)    NULL,
    [SecondAuditPerson] NVARCHAR (50)    NULL,
    [SecondAuditTime]   DATETIME         NULL,
    [ExecDate]          DATETIME         NULL,
    [IsExec]            BIT              CONSTRAINT [DF_Employee_PostMove_IsEexc] DEFAULT ((0)) NULL,
    [BXZJB]             NVARCHAR (50)    NULL,
    [AXZJB]             NVARCHAR (50)    NULL,
    [IsCore]            BIT              CONSTRAINT [DF_Employee_PostMove_IsCore] DEFAULT ((0)) NULL,
    [GID]               UNIQUEIDENTIFIER CONSTRAINT [DF_Employee_PostMove_GID_1] DEFAULT (newid()) NULL,
    CONSTRAINT [PK_Employee_PostMove] PRIMARY KEY CLUSTERED ([id] ASC)
);


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'是否核心人员', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'Employee_PostMove', @level2type = N'COLUMN', @level2name = N'IsCore';

